package com.atguigu.edupublisher.mapper;

import com.atguigu.edupublisher.beans.TestQuestionAmount;
import com.atguigu.edupublisher.beans.TradeProvinceOrderCt;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface TestStatsMapper {


    @Select("select questionId,sum(questionRightCount),sum(questionCount)," +
            "sum(questionRightUniqueUserCount),sum(questionUniqueUserCount) from dws_test_question_window where toYYYYMMDD(stt)=#{date} group by questionId")
    List<TestQuestionAmount> selectQuestionAmount(Integer date);
}
